SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwbdivisionesaabrir
AS
SELECT     dbo.tb_DivisionesAAbrir.IdDivision AS ID, dbo.tb_DivisionesAAbrir.Reestructura, dbo.tb_DivisionesAAbrir.Descripcion, 
                      dbo.tb_GrupoDeCarreras.descripcion AS GrupoCarreras
FROM         dbo.tb_DivisionesAAbrir INNER JOIN
                      dbo.tb_GrupoDeCarreras ON dbo.tb_DivisionesAAbrir.GrupoCarreras = dbo.tb_GrupoDeCarreras.idGrupoCarrera
GO
GRANT SELECT ON  [dbo].[vwbdivisionesaabrir] TO [Informatica]
GRANT INSERT ON  [dbo].[vwbdivisionesaabrir] TO [Informatica]
GRANT DELETE ON  [dbo].[vwbdivisionesaabrir] TO [Informatica]
GRANT UPDATE ON  [dbo].[vwbdivisionesaabrir] TO [Informatica]
GRANT SELECT ON  [dbo].[vwbdivisionesaabrir] TO [SoloVer]
GO
